package jpa.entitys.synchro.staging;

import java.io.Serializable;
import java.math.BigDecimal;

import javax.persistence.*;

import java.util.Date;

import jpa.entitys.synchro.common.CommonEntity;


/**
 * The persistent class for the PS_WBS_MASTER database table.
 * 
 */
@Entity
@Table(name="PS_WBS_MASTER")
@NamedQueries({
    @NamedQuery(name = "PsWbsMaster.findAll", query = " SELECT c FROM PsWbsMaster c "),
    @NamedQuery(name = "PsWbsMaster.findById", query = " SELECT c FROM PsWbsMaster c WHERE  c.promisStagingId = :Id "),
    @NamedQuery(name = "PsWbsMaster.findIsSync", query = " SELECT c FROM PsWbsMaster c WHERE  c.issync = :issync "),
    @NamedQuery(name = "PsWbsMaster.findInstanceNo", query = " SELECT c FROM PsWbsMaster c WHERE  c.instanceNo = :instanceNo And c.issync = :issync order by c.company,c.project,c.buildingPhase,c.zoneCode,c.floorZone,c.phaseCode,c.unitNumber,c.promisStagingId asc"),
    @NamedQuery(name = "PsWbsMaster.findInstanceNo1", query = " SELECT c FROM PsWbsMaster c WHERE  c.instanceNo = :instanceNo order by c.promisStagingId asc"),
    @NamedQuery(name = "PsWbsMaster.findByUnitNumber", query = " SELECT c FROM PsWbsMaster c WHERE  c.company = :company And c.project = :project And c.buildingPhase = :buildingPhase And c.floorZone = :floorZone And c.unitNumber = :unitNumber And c.issync = :issync"),
    @NamedQuery(name = "PsWbsMaster.findByUnitNumber1", query = " SELECT c FROM PsWbsMaster c WHERE  c.company = :company And c.project = :project And c.buildingPhase = :buildingPhase And c.floorZone = :floorZone And c.unitNumber = :unitNumber And c.instanceNo = :instanceNo And c.issync = :issync order by c.promisStagingId asc")
    })
public class PsWbsMaster extends CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID")
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_HANDLER")
	private String actionHandler;

	@Column(name="BUILDING_PHASE")
	private String buildingPhase;

	@Column(name="BUILDING_PHASE_NAME")
	private String buildingPhaseName;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_ON")
	private String createdOn;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	private String isactive;

	private String issync;

	@Column(name="MODELS_DESCRIPTION")
	private String modelsDescription;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	@Column(name="PRODUCT_CODE")
	private String productCode;

	@Column(name="PROPERTY_TYPE_CODE")
	private String propertyTypeCode;

	@Column(name="SAP_PLANT_CODE")
	private String sapPlantCode;

	private String status;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Column(name="UPDATED_ON")
	private String updatedOn;

	@Column(name="ZONE_CODE")
	private String zoneCode;

	@Column(name="ZONE_CODE_NAME")
	private String zoneCodeName;
	
	@Column(name="CONS_STATUS")
	private String consStatus;
	
	@Column(name="SALE_STATUS")
	private String salesStatus;
	
	@Column(name="CONS_STATUS_NAME")
	private String consStatusName;
	
	@Column(name="SALE_STATUS_NAME")
	private String salesStatusName;
	
	@Column(name="MODELS_CODE", length=30)
	private String modelsCode;
	
	@Column(name="ROOM_AREA")
	private String roomArea;
	
	@Column(name="FINAL_AREA")
	private String finalArea;	
	
	@Column(name="HOME_NO", length=100)
	private String homeNo;
	
	@Column(name="PHASE_CODE", length=30)
	private String phaseCode;
	
	@Column(name="MODEL_REVISION", length=30)
	private String modelRevision;
	
	@Column(name="MODEL_SUB_REVISION", length=10)
	private String modelSubRevision;
	
	@Column(name="COMPANY", length=100)
	private String company;
	
	@Column(name="PROJECT", length=100)
	private String project;
	
	@Column(name="FLOOR_ZONE", length=100)
	private String floorZone;

	@Column(name="REF_SYNC_PK_ID", length=100)
	private String refSyncPkId;
	
	@Column(name="INTERFACE_NO", length=100)
	private String interfaceNo;
	
	@Column(name="ACTUAL_SALE_AREA", length=100)
	private String actualSalesArea;	
	
    /**
	 * @return the actualSalesArea
	 */
	public String getActualSalesArea() {
		return actualSalesArea;
	}

	/**
	 * @param actualSalesArea the actualSalesArea to set
	 */
	public void setActualSalesArea(String actualSalesArea) {
		this.actualSalesArea = actualSalesArea;
	}

	/**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}
	
	/**
	 * @return the refSyncPkId
	 */
	public String getRefSyncPkId() {
		return refSyncPkId;
	}

	/**
	 * @param refSyncPkId the refSyncPkId to set
	 */
	public void setRefSyncPkId(String refSyncPkId) {
		this.refSyncPkId = refSyncPkId;
	}
	
	/**
	 * @return the floorZone
	 */
	public String getFloorZone() {
		return floorZone;
	}

	/**
	 * @param floorZone the floorZone to set
	 */
	public void setFloorZone(String floorZone) {
		this.floorZone = floorZone;
	}

	/**
	 * @return the company
	 */
	public String getCompany() {
		return company;
	}

	/**
	 * @param company the company to set
	 */
	public void setCompany(String company) {
		this.company = company;
	}

	/**
	 * @return the project
	 */
	public String getProject() {
		return project;
	}

	/**
	 * @param project the project to set
	 */
	public void setProject(String project) {
		this.project = project;
	}

	/**
	 * @return the modelSubRevision
	 */
	public String getModelSubRevision() {
		return modelSubRevision;
	}

	/**
	 * @param modelSubRevision the modelSubRevision to set
	 */
	public void setModelSubRevision(String modelSubRevision) {
		this.modelSubRevision = modelSubRevision;
	}

	/**
	 * @return the modelRevision
	 */
	public String getModelRevision() {
		return modelRevision;
	}

	/**
	 * @param modelRevision the modelRevision to set
	 */
	public void setModelRevision(String modelRevision) {
		this.modelRevision = modelRevision;
	}

	/**
	 * @return the phaseCode
	 */
	public String getPhaseCode() {
		return phaseCode;
	}

	/**
	 * @param phaseCode the phaseCode to set
	 */
	public void setPhaseCode(String phaseCode) {
		this.phaseCode = phaseCode;
	}

	/**
	 * @return the homeNo
	 */
	public String getHomeNo() {
		return homeNo;
	}

	/**
	 * @param homeNo the homeNo to set
	 */
	public void setHomeNo(String homeNo) {
		this.homeNo = homeNo;
	}

	/**
	 * @return the roomArea
	 */
	public String getRoomArea() {
		return roomArea;
	}

	/**
	 * @param roomArea the roomArea to set
	 */
	public void setRoomArea(String roomArea) {
		this.roomArea = roomArea;
	}

	/**
	 * @return the finalArea
	 */
	public String getFinalArea() {
		return finalArea;
	}

	/**
	 * @param finalArea the finalArea to set
	 */
	public void setFinalArea(String finalArea) {
		this.finalArea = finalArea;
	}

	/**
	 * @return the modelsCode
	 */
	public String getModelsCode() {
		return modelsCode;
	}

	/**
	 * @param modelsCode the modelsCode to set
	 */
	public void setModelsCode(String modelsCode) {
		this.modelsCode = modelsCode;
	}

	/**
	 * @return the consStatusName
	 */
	public String getConsStatusName() {
		return consStatusName;
	}

	/**
	 * @param consStatusName the consStatusName to set
	 */
	public void setConsStatusName(String consStatusName) {
		this.consStatusName = consStatusName;
	}

	/**
	 * @return the salesStatusName
	 */
	public String getSalesStatusName() {
		return salesStatusName;
	}

	/**
	 * @param salesStatusName the salesStatusName to set
	 */
	public void setSalesStatusName(String salesStatusName) {
		this.salesStatusName = salesStatusName;
	}

	/**
	 * @return the consStatus
	 */
	public String getConsStatus() {
		return consStatus;
	}

	/**
	 * @param consStatus the consStatus to set
	 */
	public void setConsStatus(String consStatus) {
		this.consStatus = consStatus;
	}

	/**
	 * @return the salesStatus
	 */
	public String getSalesStatus() {
		return salesStatus;
	}

	/**
	 * @param salesStatus the salesStatus to set
	 */
	public void setSalesStatus(String salesStatus) {
		this.salesStatus = salesStatus;
	}

	public PsWbsMaster() {
    }

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getBuildingPhase() {
		return this.buildingPhase;
	}

	public void setBuildingPhase(String buildingPhase) {
		this.buildingPhase = buildingPhase;
	}

	public String getBuildingPhaseName() {
		return this.buildingPhaseName;
	}

	public void setBuildingPhaseName(String buildingPhaseName) {
		this.buildingPhaseName = buildingPhaseName;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getModelsDescription() {
		return this.modelsDescription;
	}

	public void setModelsDescription(String modelsDescription) {
		this.modelsDescription = modelsDescription;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getProductCode() {
		return this.productCode;
	}

	public void setProductCode(String productCode) {
		this.productCode = productCode;
	}

	public String getPropertyTypeCode() {
		return this.propertyTypeCode;
	}

	public void setPropertyTypeCode(String propertyTypeCode) {
		this.propertyTypeCode = propertyTypeCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

	public String getZoneCode() {
		return this.zoneCode;
	}

	public void setZoneCode(String zoneCode) {
		this.zoneCode = zoneCode;
	}

	public String getZoneCodeName() {
		return this.zoneCodeName;
	}

	public void setZoneCodeName(String zoneCodeName) {
		this.zoneCodeName = zoneCodeName;
	}

}